Senior Analytics / Data Warehouse Developer


On Site
USD 120,000.00 - 150,000.00 per year
Contract - W2


Cross-functional team
Master data management
Dimensional modeling
Oracle Data Integrator
Microsoft Office
Data warehouse
Financial software
Data flow
Data structure
Requirements elicitation
Functional requirements
Business process
System administration
Regression testing
Development testing
Knowledge base
Software design
End-user training
Shell scripting
Problem solving
Oracle BI Publisher
Star schema
Data Analysis
Data profiling
Financial management
Computer science
Information management
Government contracting
Financial planning
Customer Care and Billing
Internationalization and localization
Snow flake schema
Microsoft Excel
Microsoft Outlook
Cloud computing

Job Details

ECS is seeking a Senior Analytics / Data Warehouse Developer to work Remote .

Job Description:
ECS is seeking a Senior Analytics / Data Warehouse Developer to join the Financial Systems team. This is an exciting opportunity for a highly motivated individual who requires minimal supervision, but also excels within a cross-functional team environment.

The right candidate will:
Design, develop and modify relational and multidimensional database structures, relationships, data flows and data interfaces within the Data Warehouse
Document and maintain thorough understanding of the architecture, data structures and design principles of the Data Warehouse
Work collaboratively with functional business leaders to support the functional and technical requirements of the Data Warehouse and analytics solution
Develop cross-functional relationships to maintain an understanding of issues and developing solutions that meet business and technical requirements.
Participation in requirements gathering sessions with ECS internal customers, translation of functional requirements to technical designs and implementing solutions that meet these customer requirements.
Analyze the effectiveness and efficiency of existing business processes and business requests and recommend solutions using system standards and best practices
Responsible for system administration and development for Oracle OCI/ADW/OAC/ODI and related tool(s)
Regression testing of Oracle software updates and patches
Provide primary support in the development, testing, and maintenance of reports and dashboards as requested by users and in concert with Financial Systems CCB approval process
Oversee master data management and governance
Maintain Knowledge Base documentation of systems and processes including end-user procedures, application design, and admin processes
Lead formal periodic user training sessions highlighting new development releases to the user community

Salary: $120,000 - $150,000

Required Skills:
PL/SQL (writing packages, procedures, functions, triggers and views)
Experience with CEMLI (Customization, Extension, Modification, Localization and Integration)
Experience with Data Warehouse design and table structures
Shell scripting and Java experience
Strong trouble-shooting, problem resolution, and writing technical specification skills
Experience with Oracle Dashboards, and BI Publisher.
Experience with star-schema, snowflake, fact, and dimensional data modeling against an Oracle database
Experience as an Oracle BI developer using OAC/OBIEE with extensive expertise in RPD design/development
Ability to design reports in a logical, user friendly, and easy to understand format.
Experience in data analysis, data profiling and validation
Experience with Oracle Data Integrator or similar tool(s)
Skilled and experienced with graphical elements and filtered/layered reporting with drill down capabilities
Ability to communicate effectively
Ability to quickly comprehend processes and willingness to learn systems and tools
Responsive with customer requests including the ability to balance priorities and work activities
Demonstrated knowledge with budget and financial management analysis
Ability to work across functional and technical departments
Effective interpersonal (written, verbal, and presentation) skills
Proficiency with Microsoft Office tools (Word, Excel, PowerPoint, Outlook)
Ability to think critically to solve problems without outside support or guidance

Desired Skills:
Bachelor's Degree in Computer Science, Information Management, Finance, or comparable
Preferred government contracting or related industry experience
Experience supporting large government contractor(s) (>$500m)
Strong understanding of financial planning processes and how they integrate with other areas of the organization
Familiarity with Costpoint is highly desirable
Familiarity with Salesforce
Experience with Oracle EPM Cloud Products and Solutions (EPBCS, PBCS)

ECS is an equal opportunity employer and does not discriminate or allow discrimination on the basis of race, color, religion, gender, age, national origin, citizenship, disability, veteran status or any other classification protected by federal, state, or local law. ECS promotes affirmative action for minorities, women, disabled persons, and veterans.

ECS is a leading mid-sized provider of technology services to the United States Federal Government. We are focused on people, values and purpose. Every day, our 3000+ employees focus on providing their technical talent to support the Federal Agencies and Departments of the US Government to serve, protect and defend the American People.

General Description of Benefits