Senior Data Engineer

Profile

Position Summary
The Senior Data Engineer plans, coordinates, and supervises all activities related to the design, development, and implementation of reporting enterprise data models and data integration. The Senior Data Engineer is also responsible for maintaining, supporting, and upgrading the existing data warehouse and other reporting data repositories. This individual will apply proven communication skills, problem-solving skills, and knowledge of best practices to guide development on issues related to the design, development, and deployment of mission-critical reporting data repositories.
The position will report to the Assistant VP of Database Development and Data Architecture. Guidance around data governance with regard to software development controls, overall system design and pre/post production processes (e.g., release, testing guidelines, necessary design and development artifacts, etc.) will come from the supervisor. The VP of Data Management will provide direction for necessary reporting content and level of service required to meet reporting needs.
Primary Responsibilities
Lead design efforts by evaluating proposals in order to identify potential problem areas, and make the appropriate recommendations.
Ensure that implementation of the Data Warehouse meets business requirements and provides the expected business outcomes.
Identify and resolve reporting and system data integration systems issues.
Review and analyze existing data warehouse effectiveness and efficiency, and then develop strategies for improving or leveraging the data warehouse with a focus on following best practices and standards.
Participate in project scope identification, data architecture development and project planning in coordination with other members of the data warehouse team.
Oversee and lead SQL program and mapping development (design, develop, test, deploy) utilizing a defined develops processes and internal standards.
Develop data transformation processes and automating load processes while maintaining, updating, and modernizing legacy acquisition and loading processes.
Consult with internal and external business customers, application areas and other technical support areas on Data migration/Data Warehousing related topics.
Develop monitoring systems and remedial processes to ensure data loads always occur on schedule and data is accurate.
Assure all programs are documented using standardized documentation procedures
Provide project leadership on projects as assigned and demonstrate solid project management skills of planning, organizing, and controlling the scope, schedule, and budget including but not limited to provide accurate delivery estimates.
Assume major responsibility for resolving problems in assigned systems.
Incumbent will be responsible for meeting RoundPoint’s commitment to compliance
Qualifications
Formal Education & Certification
Four-year college diploma or university degree in management information systems, computer systems design or computer science, and/or 7 years equivalent work experience.
Certifications in related areas including Microsoft certifications with a concentration in SQL Server development or Data Warehousing are desirable.
Knowledge & Experience
Detailed experience with designing, building and supporting medium to large data warehouses
Familiarity with one or more of the data warehouse patterns and methodologies such as Kimball, Inmon, or Data Vault.
Experience with dimensional modeling, star schemas with a clear understanding of facts and dimension table structures and uses with a strong focus on trend reporting and other OLAP analysis.
Technically fluent in SQL Server database development including logical and physical data structure design including data partitioning, in-memory tables, column store indexes and development of stored procedures and functions optimized for query / reporting performance
Desired candidate has working knowledge of multidimensional cubes and/or tabular data models.
Ability to execute and implement the organization’s goals and objectives.
Knowledge of applicable data privacy practices and laws such as GDPR and CCPA.
Personal Attributes
Strong customer-service orientation.
Excellent listening and interpersonal skills.
Ability to communicate ideas in both technical and business language.
Ability to conduct research into database development issues and products.
Highly self-motivated and directed.
Keen attention to detail.
Able to prioritize and execute tasks in a high-pressure environment.
Experience working in a team-oriented, collaborative environment.
RoundPoint’s Employee Value Proposition:
Grow. Make a difference. Have fun along the way.
Our mission is to serve our homeowners and all of their homeownership needs. We do this by embracing challenges, executing with excellence, and fostering a positive work culture that encourages personal and professional growth. We are on the fast track to becoming the premier marketplace for all things home, and the National Mortgage News and Best Companies Group just named us one of 2019's Best Mortgage Companies to Work For! Without a doubt, RoundPointers are what make this company a great place to work! That’s why we hire individuals who share our core values: Energy, Ethics, Execution, Everyone, and Earn it!
As a RoundPointer, we will empower you to innovate, provide meaningful solutions, set goals and crush them, play hard, and give back to the community! Our secret sauce is our mantra, All In. All Win. Together, we can achieve great things!
Physical Demands & Working Conditions
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job:
The employee is regularly required to talk or hear.
The employee is required to sit for extended periods of time and is occasionally required to stand and walk.
The employee must regularly use hands to finger, handle, or feel objects and is regularly required to reach with hands and arms; the employee may occasionally climb or balance, and stoop, kneel, crouch, or crawl.
The employee must frequently lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.
Specific vision abilities required by this job include close vision, distance vision, color vision, and ability to adjust focus.
The noise level in the work environment is usually quiet to moderate, and no extreme conditions are present.

Company info

Sign Up Now - WashingtondcCrossing.com