BI Developer / Architect – Microsoft

Location: New Castle, PA

Job Type: Contract to Hire

We are seeking IT Professionals for our Solutions Developer position who are detail oriented, passionate about problem solving and providing solutions, and desire to provide superior support to the organization. As a growing organization, our commitment to the development of our teams provides opportunities for a rewarding career path.


  • Responsible for system design, coding, testing and maintenance within our Microsoft data warehouse and business intelligence platforms
  • Lead report writer using T-SQL while fully understanding the Microsoft SQL platform (SSRS/SSIS/SSAS)
  • Build and create ETL processes with extensive Microsoft SSIS capabilities
  • Develop custom code and Microsoft SQL code to support delivery and presentation of data warehouse
  • Design, develop, and support data marts utilized by mission critical data warehouse applications
  • Create data flows and conceptual models defining the informational needs of solutions
  • Develop and maintain data architecture, data management standards/conventions, data dictionaries, data element naming standards & data dictionary metadata standards
  • Assist cross-functional team members to recommend technical solutions to business issues and/or system issues
  • Propose technical recommendations for more efficient troubleshooting and issue resolution
  • Apply generally accepted programming standards and techniques to assure efficient program logic and data manipulation
  • Acts as code reviewer for other application developers’ output to enforce accepted programming standards and techniques
  • Work with Power BI and Azure Platforms
  • Enforces Software Development Lifecycle (SDLC)

Education & Experience:

  • Bachelor’s Degree in Computer Science or Business Administration
  • 3 years’ architecting and building data warehouses
  • 2 years using ETL tools (SSIS)
  • 6 years SQL programming with Microsoft SQL 2005/2008/2012/2014
  • 4 years of application development experience in the medical vertical preferred but not required
  • 2 plus years of Power BI and Azure
  • Strong knowledge of dimensional data modeling and star schema design
  • Experience in current software engineering and solution delivery methodologies