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 Data Analysis, SQL Query Creation, and Data Pipeline Development, with a strong focus on RDBMS technologies and SDLC processes. Proven ability to mentor junior engineers and enhance business processes through innovative solutions.
Highest-signal resume keywords
SQL Query CreationData AnalysisRDBMS (Oracle, MS SQL Server, Teradata, Snowflake)Data Pipeline DevelopmentSDLC Process
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data MappingData IngestionData MiningData AggregationData StandardizationQuality Check MechanismsETL ToolsProgramming LanguagesRelational DatabasesTechnical Defect Requirements
Soft Skills
MentoringProblem SolvingCollaborationCommunication
Tools & Technologies
JiraMicrosoft Office SuiteHadoopSpark
Industry Keywords
Media IndustryRetail IndustryHealthcare IndustryPayments Processing
Tech Stack
Tools & technologiesETLHadoopMS SQL ServerOracleRDBMSSDLCSparkSQL
About the role
Key responsibilities & impact- Create and execute complex SQL queries
- Provide subject matter expertise in Data Mapping, Programming, and Ingestion workflows
- Perform data analysis, data mining, and investigation using SQL and/or Oracle
- Deploy, configure, and monitor production solutions and services
- Mentor junior-level engineers and train new and junior-level system analysts
- Identify organizational improvements and recommend business process enhancements
- Validate new technology requirements are integrated within existing processes and product functionality
- Write technical defect requirements and create or update standard operating procedures
- Participate in project meetings and contribute to the SDLC
- Troubleshoot and provide solutions for complex problems
- Monitor system functions and assist with resolving processing problems
- Research and analyze client data inquiries using internal data sources
- Perform implementation functions, including testing new file extracts and providing defect and enhancement support to development and product teams
- Provide technical operational expertise to Engineering teams for troubleshooting and new functionality requirements
- Develop innovative ideas using multi-disciplinary knowledge
- Complete projects associated with departmental objectives
Requirements
What you’ll need- Bachelor’s degree or equivalent in Computer Science, Electrical Engineering or related
- Eight (8) years of experience in data analysis and data pipeline development in the media, retail, healthcare or other payments processing industry(ies)
- Eight (8) years of experience with data aggregation, standardization, linking, quality check mechanisms and reporting
- Eight (8) years of experience with RDBMS (Oracle, MS SQL Server, Teradata, and Snowflake) and using SQL or other data integration/ETL tools
- Eight (8) years of experience with programming languages, operating systems, computer hardware platforms
- Five (5) years of experience working with relational databases and ETL database functions
- Five (5) years of experience in a data production environment supporting System Development Life Cycle (SDLC) process
- Any amount of experience with Big data technologies including Hadoop and Spark
- Any amount of experience with ticketing and documentation tools including Jira
- Any amount of experience applying best practices in coding including development and deployment
- Any amount of experience with Microsoft Office Suite including PowerPoint, Word, Excel, Outlook and Project
- Any and all experience may be gained concurrently
- Ability to work remotely anywhere in the U.S.
Benefits
Comp & perks- Medical insurance coverage
- Dental insurance coverage
- Vision insurance coverage
- Disability insurance coverage
- Life insurance coverage
- 401(k) savings plan
- Paid family leave
- 9 paid holidays per year
- 17–27 days of Paid Time Off (PTO) per year, depending on specific level and length of service
