Hi Osei,
This is Urvish from Cambay Consulting LLC, I tried to reach you regarding an amazing opportunity with Multnomah County – Department of County Human Services for the position of Senior Business Intelligence Developer in Portland, OR.
Kindly go through the email below and let me know the best time to reach you.
Position Details:
Client: | Multnomah County - Department of County Human Services |
Job Title: | Senior Business Intelligence Developer |
Location: | 501 SE Hawthorne Blvd. Suite 175 Portland, OR 97214 |
Duration: | 12+ Month |
Job Description:
Background: The Enterprise Data and Analytics (EDAT) Team provides the data in our Data Warehouses. We are focused on the successful adoption of Business Intelligence tools throughout the county. The officially supported BI tools are: SQL Server Reporting Services (SSRS) and Tableau. We are exploring Power BI.
This BI Developer will be assigned production support and work items prioritized by our Department of County Human Services (DCHS)
Scope of Work: This ETL Developer is responsible for production support and implementing small, medium and large scale BI projects. This person will develop and maintain TSQL, SSIS and/or ADF based ETL data integration solutions. This developer could also be supporting the DCHS Application Team items (.NET and C# development middle tier and back end focused).
Required Skills and Abilities:
● Bachelor's Degree from an accredited college or university or equivalent practical and relevant experience.
● Seven (7) years of IT Development experience.
● This position must pass a criminal history records check.
The skills:
* Advanced experience working on ETLs
* Advanced experience with Azure, Azure DevOps, and Azure SQL Server
* Advanced experience with T-SQL
* Advanced experience with .NET
* Advanced experience in data warehousing design, BI concepts and best practices
* Advanced experience in job scheduling tool / scheduling tasks and processes
* Advanced experience in scripting languages (JavaScript, PowerShell, Command scripting)
* Advanced experience in programming languages such as C# and Python
* Advanced experience in SQL programming including stored procedures, query plans, functions, views, indexes and triggers
* Advanced experience building ETLs for loading data for reporting
* Advanced experience in database modeling, data conversion and ETL tools such as SSIS
The work:
• Develop complex ETL routines to load a dimensional star schema (and supporting layers) inclusive of data quality, error handling, and logging processes
• Determine strategies for data integrity validation processes
• Resolve difficult design and development issues
• Remain current on new ETL techniques and methodologies and communicate trends.
• Assess requirements for completeness and accuracy and determine if requirements are actionable for the ETL team
• Conduct impact assessment and determine the size of effort based on requirements
• Identify necessary changes to current business and data integration processes
• Communicate risks and ensure understanding of these risks
Experience that provides a plus:
* ETL experience for the Health and Human Services industry
* Tableau experience
* SSRS experience
* Power BI experience
* Exposure to cloud technologies Azure Data Factories, Custom controls such as (telerik, Dev Express, Progress Kendo UI, etc)
Thanks and Best regards,
Urvish Rai
Ph.: 832-761-3192
Cambay Consulting LLC.
1838 Snake River Road,
Suite A, Katy, TX 77449
::DISCLAIMER::
The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or CAMBAY or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of CAMBAY or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of CAMBAY is strictly prohibited. If you have received this email in error, please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.