Data Architect

Job DetailsJob Location: New York, NY 10004Position Type: Full TimeSenior Data Engineer / Data Architect   New York, NY or Remote    Bright Power works with forward thinking owners and developers to identify, design, and implement custom energy and water solutions on a wide variety of systems. Our team is a diverse, talented, and hard-working group of individuals committed to growing this industry and to making a positive impact on the environment.    Join Us  Bright Power is comprised of a team of diverse, talented, and hard-working individuals committed to growing this industry and making a positive impact on the environment. We are passionate about reducing energy and water usage by implementing energy efficiency and renewable energy technologies. Our goal is to improve the health, comfort, and value of our client’s buildings, while cultivating a sustainable future. We believe deeply in doing well by doing good and come to work every day seeking to change the world.     The Role   Bright Power is seeking a Data Architect / Senior Data Engineer to work alongside Data Services and Software under the direction of the SVP, Data & Product Strategy in developing and maintaining a complex data infrastructure for all of Bright Power.  As a Data Architect, you will be the primary decision-maker on how our data infrastructure is designed and built. You’ll be trusted to weigh business needs and trade-offs, including cost, complexity, timeline, maintainability, and team capacity. You’ll recommend and defend the approach that best serves Bright Power’s actual business needs and play a key role in helping junior members of the Data Team grow their technical skills.    Primary Responsibilities  Own architecture and infrastructure decisions. Evaluate trade-offs, including cost, complexity, timeline, maintainability, and team capacity. Recommend and defend the approach that best serves Bright Power’s actual business needs.  Develop a thorough understanding of business needs and priorities across Data Services, Software, and service delivery teams in order to design and recommend approaches with the highest business impact.   Design, build, and optimize data sets, ETL workflows and data pipelines, and architectures: Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating data pipelines  Gain thorough understanding of business needs and priorities in order to recommend and design approaches with highest impact  Collaborate with cross-functional teams to build pipelines and processes that are dependable, well monitored, and issues are clearly communicated to stakeholders when discovered and as they are repaired  Create and maintain automated/regression tests, setup alerts, monitor pipelines/workflows, and fix data pipeline problems  Perform root cause analysis on external and internal processes and data to identify opportunities for process improvement and test creation.  Serve as both a technical expert on the data solutions team and as a technical guide to other data solutions team members.  Serve as an escalation point and subject matter expert during major data pipeline incidents and coordinate the issue resolution with key internal and external stakeholders.  Ensure data quality through collaboration with the company's premier data vendor partners by identifying data problems, communicating them to the vendor, and verifying when they are rectified.  As part of an Agile project and operations team; design, develop, test, implement and support technical solutions across full-stack development tools and technologies   Other work as assigned  QualificationsSkills/Qualifications  Proven experience as a data architect or senior data engineer, including experience owning architecture decisions and being accountable for their outcomes.  Demonstrated ability to evaluate technical trade-offs and make sound, well-reasoned recommendations on infrastructure and architecture choices grounded in business needs and value.  5+ years of proven administrative or development experience with Data infrastructure, complex data modeling, AWS environments, ETL workflows, and data APIs  Technically proficient in data systems administration  Proficiency with AWS Athena, MySQL, and Postgres, Linux or WSL, Git, programming with Python using pandas, and building pipelines with AWS Glue  Proficiency with RDS, database documentation, and data lake architecture  Excellent organizational and time management skills  Strong work ethic and able to work independently and multitask  Critical thinking and problems solving abilities  Excellent verbal and written communication skills; ability to clearly articulate areas of opportunity across multiple technology domains  Proven track record in working as part of a team to maintain and improve internal systems  Interest in learning about buildings, construction, and its relation to energy and   environmental issues.  Passion for sustainability, climate change mitigation, and/or creating healthier buildings    Salary: $100,000 - $130,000   Benefits  In addition to working with incredible people, Bright Power offers competitive benefits. Find the list of our benefits offered on our careers home page    EQUAL EMPLOYMENT OPPORTUNITIES Bright Power provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Bright Power complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Bright Power expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Bright Power’s employees to perform their job duties may result in discipline up to and including discharge.