What are the responsibilities and job description for the SQL/Power BI Developer w/ Python position at Yoh - A Day & Zimmerman Company?
Job Details
SQL/Power BI Developer (w/ Python)
6 month contract to hire
Addison, TX (Remote)
Must have Power BI, Python, T-SQL (Knowledge of Azure Data Factory (ADF) and Databricks)
The Database Developer is responsible for working with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses.
The successful candidate will create technical designs within the existing architecture and develop complex SQL query logic to accomplish the task.
Design and develops database applications using SQL Server Integration Services, T-SQL and Stored Procedures.
Consult with the business to determine logical design for new business solutions according to existing data architecture
Perform code reviews, analyze execution plans, and re-factor inefficient code
Follows data standards, resolves data issues, completes unit testing and completes system documentation for ETL processes
Collaborate with business analysts, source system experts, and other team members to determine data extraction and transformation requirements
Collaborate with IT operations and testing organizations to ensure timely releases of projects and database environments are sustainable
Collaborate with IT operations for support in problem resolution and root cause analysis.
Support IT staff and business users in the development, usage and troubleshooting of database-driven applications
Participate in special projects as needed and performs other duties as assigned.
Requirements
Strong experience with T-SQL, DAX, Azure Data Factory (ADF), Databricks, Paginated Reports, Power BI
Big pluses - Python, SSRS, SSIS, SQL Server Database Architecture and Design (OLTP/OLAP), and SQL Server Database Programming and Development. SQL Server 2000 -2016
Strong experience with T-SQL, Stored Procedures, Triggers and DTS development.
Estimated Min Base: $60hr W2
Estimated Max Base: $65hr W2
Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.
Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Visit to contact us if you are an individual with a disability and require accommodation in the application process.
For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.
6 month contract to hire
Addison, TX (Remote)
Must have Power BI, Python, T-SQL (Knowledge of Azure Data Factory (ADF) and Databricks)
The Database Developer is responsible for working with business analysts and business users to gather and interpret business requirements for multiple financial and healthcare systems including large data warehouses.
The successful candidate will create technical designs within the existing architecture and develop complex SQL query logic to accomplish the task.
Design and develops database applications using SQL Server Integration Services, T-SQL and Stored Procedures.
Consult with the business to determine logical design for new business solutions according to existing data architecture
Perform code reviews, analyze execution plans, and re-factor inefficient code
Follows data standards, resolves data issues, completes unit testing and completes system documentation for ETL processes
Collaborate with business analysts, source system experts, and other team members to determine data extraction and transformation requirements
Collaborate with IT operations and testing organizations to ensure timely releases of projects and database environments are sustainable
Collaborate with IT operations for support in problem resolution and root cause analysis.
Support IT staff and business users in the development, usage and troubleshooting of database-driven applications
Participate in special projects as needed and performs other duties as assigned.
Requirements
Strong experience with T-SQL, DAX, Azure Data Factory (ADF), Databricks, Paginated Reports, Power BI
Big pluses - Python, SSRS, SSIS, SQL Server Database Architecture and Design (OLTP/OLAP), and SQL Server Database Programming and Development. SQL Server 2000 -2016
Strong experience with T-SQL, Stored Procedures, Triggers and DTS development.
Estimated Min Base: $60hr W2
Estimated Max Base: $65hr W2
Note: Any pay ranges displayed are estimations. Actual pay is determined by an applicant's experience, technical expertise, and other qualifications as listed in the job description. All qualified applicants are welcome to apply.
Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Visit to contact us if you are an individual with a disability and require accommodation in the application process.
For California applicants, qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. All of the material job duties described in this posting are job duties for which a criminal history may have a direct, adverse, and negative relationship potentially resulting in the withdrawal of a conditional offer of employment.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Salary : $65
