Role Description 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. The Data Solutions Developer designs, develops, and optimizes enterprise data warehouse solutions that support analytics and reporting initiatives. This role applies strong database development expertise, Azure cloud technologies, and Power BI to deliver scalable, high-quality data solutions that enable accurate insights and informed business decision-making. To be successful you must possess these core value characteristics: - Trust: Clear Communication. Be committed. Accountable. Open. Honest. - Team: No "I". Do what's best. Assume the best. Be a leader. Celebrate wins. - Grit: Goal-focused. Be positive. Persevere. Show passion. Take ownership. - Growth: Lifelong learner. Forward-thinker. Self-aware. Curious. Open-minded. Essential Duties and Responsibilities: - Design, develop, and maintain scalable and high performing data warehouse solutions. - Build and optimize ETL/ELT processes using tools such as Azure Data Factory or SSIS. - Develop complex SQL queries, stored procedures, and views for data transformation and loading. - Integrate data from multiple sources, ensuring data quality, consistency, and availability. - Work with Azure services including Azure SQL Database and Azure Data Factory. - Develop interactive and insightful Power BI dashboards and reports based on business requirements. - Collaborate with business stakeholders to understand reporting needs and translate them into technical solutions. - Monitor and improve data warehouse performance, ensuring uptime, data integrity, and scalability. - Document data models, processes, and procedures. - Perform other related duties as assigned. Qualifications - Bachelor's degree in Computer Science, Information Systems, or related field. - 3+ years of experience in data warehouse development and database programming. - Proficiency in T-SQL and relational database design (SQL Server). - Hands-on experience with Azure data platform services (e.g., Azure SQL, Synapse, Data Factory). - Strong knowledge of data modeling techniques (star/snowflake schemas). - Experience in developing Power BI dashboards, reports, and data models (DAX, Power Query). - Excellent problem-solving and communication skills. - Must demonstrate exceptional verbal and written communication skills. - Ability to work independently with minimal direct supervision. - Criminal background check required for hire. Requirements - Experience with Davisware/Sage 300 (preferred). - Familiarity with QlikView/SSRS reporting tools (preferred). Physical Requirements - Prolonged periods sitting at a desk and working on a computer. - Must be able to lift up to 15 pounds at times. - Ability to travel to various divisions and worksites as needed.

• Architect & build backend systems • Optimize performance & scalability • Enhance security & reliability • Cross-company collaboration • Contribute to code reviews • Participate in research & innovation • Interface with Customers

• Create and implement automated configuration and deployment processes to enhance the performance, accessibility, and ease of management of the platform and its related services. • Establish and manage administrator and service accounts, while also maintaining accurate system documentation and effectively resolving technical issues. • Utilize scripting tools to craft self-service capabilities within the Platform as a Service (PaaS), fostering a seamless developer experience for development teams. • Collaborate closely with developers to diagnose and troubleshoot problems, ensuring smooth operations. • Take on the operational responsibility for the services under your team's ownership. • Thrive in an environment that nurtures your personal development and growth. • Continuously enhance the product, delivering software that resonates positively with users and meets their needs effectively.

• Lead a cross-functional pod of 4-8 engineers, setting technical direction while staying hands-on • Design and build a stateless API gateway that enables external AI assistants to query IDC's intelligence platform • Architect multi-platform channel adapters for email, Slack, and Teams delivery • Build shared infrastructure: authentication, identity linking, rate limiting, thread mapping, and audit logging • Define interfaces and contracts with adjacent teams (AI Orchestration, Search & Data Services) • Write production code. This role is coding more than 50% of the time