Data Platform Developer
System One
Harrisburg, PA(remote)
JOB DETAILS
SKILLS
Background Investigation, Communication Skills, Computer Science, Data Management, Data Modeling, Data Quality, Data Warehousing, Database Design, Database Extract Transform and Load (ETL), Database Programming, Documentation, Ecosystems, Information Technology & Information Systems, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Outsourcing, Performance Tuning/Optimization, Power BI, Problem Solving Skills, Qlik, Reporting Dashboards, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Sage 300, Service Delivery, Snowflake Schema, Star Schema, Stored Procedures, Technical Support, Willing to Travel, Writing Skills
LOCATION
Harrisburg, PA(remote)
POSTED
1 day ago
Location: Harrisburg, PA
Type: Direct Hire
Contractor Work Model: Remote (Harrisburg, PA Area)
Overview
System One is seeking a Data Solutions Developer in the Harrisburg, PA area. This individual will focus on the creation, enhancement, and optimization of enterprise-level data warehouse solutions. The primary goal of this position is to utilize Azure cloud technologies, Power BI, and database expertise to provide the high-quality data necessary for informed business strategy and analytics.
**This is a remote position that may require occasional travel. We are looking for a candidate in the Greater Harrisburg area. Please note that we are unable to sponsor or take over sponsorship of employment visas at this time. Applicants must be currently authorized to work in the United States on a full-time basis.**
Primary Responsibilities
- Design and implement high-performance, scalable data warehouse architectures.
- Develop and refine ETL/ELT workflows using SSIS or Azure Data Factory.
- Author complex SQL queries, views, and stored procedures to facilitate data loading and transformation.
- Consolidate information from various sources while maintaining strict data integrity and consistency.
- Utilize Azure services, specifically Azure Data Factory and Azure SQL Database.
- Create meaningful Power BI reports and dashboards tailored to business needs.
- Partner with stakeholders to convert reporting requirements into functional technical tools.
- Manage data warehouse health, focusing on uptime, scalability, and performance tuning.
- Maintain comprehensive documentation for all data models and procedural workflows.
- Execute additional tasks as needed to support the data platform.
Education and Professional Experience
- Bachelor’s degree in Information Systems, Computer Science, or a related technical field.
- A minimum of 3 years of professional experience in database programming and data warehouse development.
- Expert-level proficiency in relational database design and T-SQL (SQL Server).
- Practical experience working within the Azure data ecosystem, including Synapse, Azure SQL, and Data Factory.
- Solid understanding of data modeling methods, such as snowflake and star schemas.
- Proficiency in Power BI development, including the use of Power Query and DAX.
- Strong communication skills and the ability to solve complex technical problems.
- Proven ability to manage tasks independently with minimal oversight.
- Willingness to undergo a criminal background check as a condition of employment.
Preferred Qualifications
- Previous experience working with Sage 300 or Davisware.
- Familiarity with reporting through SSRS or QlikView.
Travel Requirements
- Flexibility to travel to different worksites and divisions when required.
System One, and its subsidiaries including Joulé, ALTA IT Services, and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.
System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.
#M-
#LI-
#DI-
Ref: #706-IT York
About the Company
S
System One
Every day, System One focuses on services and solutions that require a high degree of specialization, in-demand technical skills, and large-scale operational expertise. We are essential partners to those on the front lines of our nation’s most critical infrastructure, technology, and life sciences initiatives.
Founded more than 40 years ago as a staffing partner to the engineering industry, today System One is a diversified organization operating in over 50 locations and putting more than 9,000 people to work in the United States, Canada, and the United Kingdom.
COMPANY SIZE
2,500 to 4,999 employeesINDUSTRY
Staffing/Employment Agencies
WEBSITE
https://systemone.com