"Data engineering is at the heart of every data\u2011driven organization, and the demand for professionals who can build reliable pipelines is soaring. Companies are eager to turn raw data into actionable insights, making hybrid roles like this one especially valuable. This contract position in Harrisburg offers you the chance to shape analytics infrastructure while enjoying a flexible work arrangement.\n\n# Job Summary\nWe are seeking a mid\u2011level Data Engineer to design, develop, and maintain scalable data systems, create Power\u202fBI dashboards, and ensure data quality across multiple sources. The role blends onsite collaboration with remote work, supporting analytics and reporting initiatives that drive strategic decisions.\n\n# Top 3 Critical Skills Table\n| Skill | Why it's critical | Mastery Level |\n|---|---|---|\n| SQL | Core for data extraction, transformation, and reporting | Mid |\n| Power BI | Enables visualization and stakeholder communication | Mid |\n| Data Modeling & Integration | Ensures scalable, reliable data structures across sources | Mid |\n\n# Interview Preparation\n1. **Describe your process for optimizing a complex SQL query.**\n *What the interviewer is looking for:* Ability to identify bottlenecks, use indexes, rewrite joins, and explain performance trade\u2011offs.\n2. **How have you designed a data model that supports both operational reporting and analytical workloads?**\n *What the interviewer is looking for:* Understanding of normalization vs. denormalization, star/snowflake schemas, and scalability considerations.\n3. **Walk me through building a Power\u202fBI dashboard from raw data to final visual.**\n *What the interviewer is looking for:* End\u2011to\u2011end workflow knowledge, data import, DAX usage, visual best practices, and stakeholder feedback loops.\n4. **What data governance practices have you implemented in past projects?**\n *What the interviewer is looking for:* Experience with data quality checks, lineage tracking, access controls, and documentation.\n5. **Explain a scenario where you integrated spatial/GIS data into a reporting solution.**\n *What the interviewer is looking for:* Familiarity with geographic data types, coordinate systems, and visualizing spatial information in Power\u202fBI.\n\n# Resume Optimization\n- Data Engineer\n- SQL\n- Power BI\n- Data Modeling\n- Data Integration\n- Data Governance\n- DAX\n- GIS\n- Dashboard Development\n- Stakeholder Collaboration\n\n# Application Strategy\nWhen reaching out to the recruiter, send a concise email that starts with a friendly greeting, attaches your updated resume, and clearly maps your top qualifications to the role. Highlight your experience with SQL and Power\u202fBI, mention any relevant projects that showcase data modeling or dashboard creation, and explicitly reference the key skills listed in the job description (e.g., data integration, stakeholder communication).\n\n# Career Roadmap\n| Current Role | Typical Experience | Core Focus | Next Position |\n|---|---|---|---|\n| Data Engineer | 2\u20114 years building pipelines, SQL, BI tools | Build and maintain data infrastructure | Senior Data Engineer |\n| Senior Data Engineer | 4\u20117 years designing scalable architectures, mentoring | Advanced data platform design & optimization | Data Engineering Lead |\n| Data Engineering Lead | 7+ years strategic planning, team leadership | Oversee multiple data projects & roadmap | Director of Data Engineering |\n"