Fulltime, Direct Hire, US Citizen or Green Card Only - 100% Remote, NO(Sponsorship, H1B, F1, OPT) - Pay $60,000 - $80,000 depending on Education, Certifications, Experience.
As the Business Intelligence ETL Data Developer and a member of our team, reporting to the Director of the Business Intelligence Center, you will have great opportunities to grow technically and professionally in multiple data driven disciplines.
Responsibilities:
- As an important member of our agile team, you will Extract Transform and Load (ETL) data from traditional databases into our cloud Snowflake database.
- Develop and deploy ETL (Extract, Transform, Load) processes and supporting programs.
- Work with essential players to develop custom Business Intelligence (BI) solutions for our client.
- Lead projects in the development and use of our BI software tools and systems.
- Lead proactive change management efforts for BI platforms integrated with enterprise applications.
- Bring new development ideas to existing applications and processes, look for ways to enhance existing specifications based on current requirements.
- Work in partnership with our client's offices to optimize use of data driven solutions, including the development of stories and test cases.
- Develop/assist end-user training and training materials and provide guidance and mentoring for the campus BI Community.
- Develop/provide documentation and support for deployed BI applications.
- Build positive relations and serve as a liaison with IT clients and IT Services staff.
Requirements:
- Candidates must have a bachelor’s degree plus 4+ years of ETL Developer Experience
- Relational database architectures at enterprise scale. Environments such as SQL Server, MySQL, Oracle, or Redshift. PL/SQL and SQL programming
- 3+ Years of Snowflake experience and experience performing database ETL to Snowflake using SnowConvert.
- Experience with Snowflake and/or conversion from OAS to Snowflake and Tableau
- Enterprise business intelligence and data analytics technologies, such as Oracle OBIEE, MS Power BI, Tableau, Oracle Warehouse Builder (OWB), and Oracle Data Integrator (ODI), Snowflake
- Industry standard data models such as Kimball’s dimensional model
- Basic troubleshooting best practices with specific focus on enterprise BI systems.
- Data analytics and BI industry trends including data mining, data modeling, machine learning, visualization, data lakes and predictive modeling.
- Analytical tools available in cloud infrastructure such as AWS, Azure, and GCP.
CBTS provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws.
