FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in designing and maintaining data pipelines, optimizing relational databases, and developing interactive reports and dashboards using Power BI. Proficient in SQL Server and MySQL, with strong capabilities in ETL processes and data validation.
Highest-signal resume keywords
MS SQL Server (T-SQL)ETL Processes Using SSISPower BI Report DevelopmentData Modeling in Power BIDAX and Power Query
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQL QueriesStored ProceduresDatabase OptimizationData ValidationReconciliation TestingData Quality RulesPerformance TuningData Processing WorkflowsBigQueryPython for Data Analysis
Soft Skills
Collaboration with StakeholdersProblem-Solving
Tools & Technologies
Power BISQL Server Integration Services (SSIS)MySQLGoogle Cloud Platform
Industry Keywords
Data PipelinesReporting ModelsBusiness ApplicationsSalesFinanceOperations
Tech Stack
Tools & technologiesBigQueryCloudETLGoogle Cloud PlatformMS SQL ServerMySQLPythonSQLSSIS
About the role
Key responsibilities & impact- Design and maintain robust data pipelines
- Optimize relational databases
- Deliver accurate reporting models supporting business decisions across sales, finance, and operations
- Write, review, and optimize complex SQL queries, stored procedures, and database structures in MS SQL Server and MySQL
- Build, deploy, and maintain ETL/ELT processes primarily using SQL Server Integration Services (SSIS)
- Build end-to-end data models, calculated columns, and measures using DAX and Power Query
- Develop, deploy, and maintain interactive Power BI reports and executive dashboards
- Conduct data validation, reconciliation testing, and root-cause analysis of data discrepancies
- Provide operational support, performance tuning, and troubleshooting for databases backing internal business applications
- Partner with software developers and non-technical stakeholders in Sales, Finance, and Contracts to translate requirements into scalable technical solutions
Requirements
What you’ll need- Strong experience with MS SQL Server (T-SQL), including complex queries, stored procedures, functions, and query performance optimization
- Good knowledge of MySQL administration and query development
- Experience building and maintaining ETL processes, particularly using SQL Server Integration Services (SSIS)
- Ability to design end-to-end data processing workflows from source systems to reporting layers
- Experience developing advanced reports and dashboards in Power BI
- Data modeling in Power BI, including relationships, hierarchies, and schema design
- Proficiency in DAX and Power Query
- Experience publishing reports and managing Power BI workspaces, including access control and security settings
- Experience in data validation and reconciliation testing
- Ability to define and implement data quality rules
- Competence identifying and analyzing business data discrepancies and errors
- Experience working in on-premises environments with SQL Server and MySQL
- Experience across DEV, TEST, and PROD development stages
- Ability to collaborate with application development teams on database integrations
- Troubleshooting and performance tuning for database systems
- Maintenance and operational support of databases used by business applications
- BigQuery experience, including SQL and ETL processes in Google Cloud Platform (nice to have)
- Basic Python knowledge for data analysis (nice to have)
Benefits
Comp & perks- Remote work arrangement
