Business Intelligence Developer
Fisher Investments
AzureCloudPythonSQLTableau
Senior Data Engineering Administrator, D365 Azure
Serigor Inc
contract
Posted on:
Origin: • 🇺🇸 United States • District of Columbia, Washington
Visit company websiteJob Level
Senior
Tech Stack
AzureOraclePythonSQL
About the role
- Provide Dataverse data management support to include schema integrity, TDS Endpoint configuration, Data extraction, query development, and data backup/restore operations
- Design, monitor, and troubleshoot scalable data pipelines in Azure Data Factory, with focus on secure ingestion, transformation, and orchestration, including monitoring and troubleshooting pipeline health and performance
- Manage Synapse workspaces (including Dataverse Link) and dedicated SQL pools/Managed SQL /Serverless SQLs, implementing advanced query optimization to support high-volume analytics and reporting workloads
- Setup and maintain Power BI workspaces, datasets, and gateways, enforcing data security permissions including row-level security
- Develop Power BI Dashboards leveraging database datasets, including log files, to determine system usage
- Develop and refine complex SQL queries to support operational and performance reporting, including audit system log analysis
- Build and maintain reusable Python scripts for parsing datasets, data cleansing, enrichment, and automation, involving structured and un-structured data
- Develop and maintain data security for datasets across Azure data services platform
- Provide data model and schema/table relationship diagram to support integrations and data exchange
- Develop and maintain data replication tools to sync Dynamics data to Synapse Analytics, including managed SQL/Dedicated SQL pool, Serverless pool destination, and API-enabled data endpoints
- Manage Legacy Oracle database, including data integrity, backup, and availability management
- Collaborate with business stakeholders to understand data requirements, mapping, and transformation needs, ensuring alignment with the child welfare information system's objectives
- Lead and coordinate Data Analysts and Reports Engineering Team activities, working closely with the system to ensure timely and accurate execution of data-dependent tasks, including Daily, Monthly, Weekly, Fiscal Year and Compliance reporting
- Perform data profiling and analysis to identify data quality issues, data gaps, and potential risks for mitigation
- Define and enforce data migration standards, best practices, and governance policies to maintain data integrity and consistency
- Create and maintain technical artifacts for data services implementation, including replication plans, data, data architecture, rules, and error reports
- Conduct training sessions and provide guidance to business staff and Functional Quality Assurance staff on data services and provide data extraction support
- Stay current with industry trends and advancements in data management methodologies and tools, recommending improvements to enhance the overall data governance
Requirements
- Bachelor’s degree in computer science, IT or related field or equivalent experience
- 15 Years Oracle Database management and administration experiences
- 15 Years Advanced SQL Query Development
- 15 Years Database security administration, including row-level security
- 15 Years Database Replication expertise, including replication schedule, rules for automatic detection of schema and table changes and validation rep results
- 15 Years Health and Human Services Data model experience
- 11 Years Project management skills with the ability to prioritize tasks and meet deadlines, including documentation of technical artifacts
- 11 Years Produce Data Model and Schema/Table link Diagram
- 11 Years Azure Data services management including Data factory, Synapse Analytics
- 2 Years Power BI Workspace Administration and Dashboard Development
- 1 Years Microsoft Azure Data Fundamentals certification
- Microsoft Certified Azure Administrator certification (highly desired)
- Python scripting knowledge (highly desired)
- Ability to report onsite 4 days a week (Hybrid work arrangement)
- Duration: 12 Months+ (Contractor)
Similar jobs on JobTailor
Senior DBA / Data Engineer
Cin7
AzureCloudETLMS SQL ServerNoSQLPostgresPythonRDBMSSQLTerraform
Senior DBA, Data Engineer
Cin7
AzureCloudETLMS SQL ServerNoSQLPostgresPythonRDBMSSQLTerraform
Senior Data Scientist
Lean Tech
AWSAzureCloudDockerETLGoogle Cloud PlatformKubernetesNoSQLPythonSQLTableau
Manager, Database Analysis and Design, Oracle, SQL, MySQL
Wolters Kluwer
AWSAzureCloudCognosInformaticaMongoDBMySQLOraclePostgresSQLSSIS