BI Developer

BI Developer

Location: Portland, OR

Duration: 6+ Months

Summary: Collaborate as part of an agile team, working with other developers, test engineers, and product managers to plan, design, code, and test reports. Developers may contribute at every level of the analytics technology stack, ranging from the reporting models, user interface, batch ETL, event streaming code, AWS based workflow scheduling, automated testing, and deployment automation.

Responsibilities:

• Ownership and responsibility for the BI data stack, which includes multiple environments for development and production.
• The architecture of ETL/ELT solutions to source and transform the data required for reporting and analytics across the business.
• Responsibility for test plans and validation solutions, to ensure the quality and integrity of our data.
• Design, develop and deploy reports using a tool like Sisense, Tableau or Birst, You understand when to use specific chart types to provide clear answers. You know how to design cubes from data mart schema. Skill with MDX is helpful.
• Experience designing fact/dimension data models and conformed dimensions. The fine balance between documentation and implementation.
• Authority over any transformations productionized in regular pipelines, in-line with coding, performance guidelines and best practices.
• Write automated tests as a routine development practice

Required Skills:

• Highly proficient in T-SQL and MS SQL Server.
• Experience working with one of the cloud offerings (Azure, AWS).
• ETL/Data Integration experience (Azure Data Factory highly preferred).
• Programming experience, preferably in C#.
• Report Development (Sisense highly preferred).
• Database design and data modeling (ER/Studio highly preferred).
• Building data pipelines, scheduling etc.
• Commercial software projects (post-release support and maintenance).
• Privacy and data governance solutions.
• Databricks, Spark.
• HTML, JavaScript, and CSS with modern frameworks.
• Single Sign-On and integrations with SaaS applications.

Founded in 2007, InterSources Inc is a Small Business Enterprise (SBE), Minority Business Enterprise (MBE) & Women-Owned Small Business (WOSB) certified Company specializing in providing IT Consulting, IT Staffing Solutions, and Software solutions. We have been recipients of Various Awards under "Fastest Growing IT Consulting and Software Company " and "Excellence in Technology Services "