Data Architect

About Us

Aquilon was founded with the idea of bringing efficiencies and transparency to the wholesale energy industry through innovative technology solutions. By working side-by-side with traders, settlement analysts, and financial professionals, Aquilon has developed a Software as a Service solution, Energy Settlement Network (ESNTM), for wholesale energy participants to reconcile all their transactions through one platform. 

Aquilon looks for individuals that demonstrate an entrepreneurial spirit and curiosity. Potential candidates can expect a fast-paced, fun, and challenging work environment surrounded by passionate and talented team members and industry experts.

Position Summary

We are looking for a highly motivated, experienced Data Architect who will be responsible for the development of architectural strategies and guidance of technical application/data solution implementations within Aquilon’s application development team. The Data Architect will collaborate with technology leadership and business stakeholders to help determine technical solutions based on business requirements and consult on their implementation. Responsibilities also include producing technical strategy to align solutions and data architecture to the company’s business strategy and goals. This position requires a strong blend of communication and technical skills.

There is enormous opportunity to develop exciting new capabilities that will key the growth of the company. Leveraging your passion and data expertise, you will be a member of the team that is transforming Aquilon.

Essential Functions and Duties

The following duties and responsibilities reflect the essential functions for this position but do not restrict the tasks that may be assigned. Management may assign or reassign duties and responsibilities to this job at any time based on business needs.

  • Evaluate/analyze business needs and current technical assets/data to develop and implement solutions and strategy for firm data and application architecture.
  • Responsible for driving data policies and standards for the management, storage, access, navigation, movement, and transformation of data.
  • Provide technical consultation for technology and data solutions based on business needs; oversee architectural aspects of business solution development/deployment.
  • Documents and drives the best practices of data architecture and data governance.
  • Design and development of MS SQL Server database objects and procedural code supporting various custom and 3rd party applications, including writing Stored Procedures, Functions, Triggers
  • Optimize and tune MS SQL databases and queries and perform database normalization
  • Work with application developers to provide data services for existing and new applications
  • Assess and maintain data integrity
  • Support and troubleshoot application issues and document solutions
  • Assist developers with complex query tuning and schema refinement.
  • Ensures that industry-accepted data architecture principles, standards, guidelines and concepts are integrated with those of allied disciplines and coordinated roll-out and adoption strategies are in place.
  • Assist in and/or lead the development and implementation of data collection systems as necessary
  • Provide mentoring on data architecture design and requirements to development and business teams
  • Reviews the solution requirements and architecture to ensure selection of appropriate technology, efficient use of resources and integration of multiple systems and technology.
  • Support presentations to Customers and Partners
  • Advising on new technology trends and possible adoption to maintain competitive advantage

Required Skills/ Qualifications

  • 15+ years of professional experience in the data field
  • At least 5 years of previous architecture experience
  • A Bachelor’s degree in Engineering/CS, IT, or related study
  • Experience and hands on capabilities with Microsoft data platform technologies: SQL Server, Azure SQL, HD Insight, Data Factory, SSIS and related tools[JK1] (ie. RedGate, Quest Benchmark, Apex, etc);
  • Excellent knowledge of data warehousing concepts & Azure
  • Significant experience working with online, web based applications; significant experience with SDLC methodologies and design/architecture aspects of project delivery.
  • Proven requirements-gathering and long-term solution development experience
  • Strong knowledge of relational database modeling principles and techniques[JK2] 
  • NoSQL experience is a preferred skill. If skill set is light on NoSQL, a willingness to increase NoSQL skillset and consider best ways to utilize within application.
  • Have demonstrated verbal and written communication skills, and the ability to interface with Business, Sales, Marketing and Executive Teams.
  • Ability to maintain strategic perspective, understanding the big picture and maintaining patience and persistence to achieve long-term goals and objectives.
  • Strong organizational, communication and presentation skills; must show experience with documenting and presenting technology strategy and experience in a strategic and consultative technical role.

To be successful at Aquilon you will be:

  • Results focused and resourceful. You are eager to enhance your skills to take your career to the next level
  • Pragmatic. You fail fast and iterate quickly
  • Entrepreneurial. You find opportunity where others don’t
  • Personable. Don’t be ‘that’ coworker
  • Open Minded. You know there are many avenues to success
  • Interested in pushing the energy industry forward

December 2014 & December 2015: CIO Review recognized Aquilon as one of the “20 Most Promising Energy Technology Solution Providers”

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • jQueryLibraries
    • AngularJSFrameworks
    • ASP.NETFrameworks
    • MVCFrameworks
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • Google AnalyticsAnalytics
    • TableauAnalytics
    • BalsamiqDesign
    • ConfluenceManagement
    • JIRAManagement
    • HubSpotCRM
    • SalesforceCRM


Our Lisle office is easily accessible from I88 and is walking distance from the train station. We're close to many restaurants and have ample parking.

An Insider's view of Aquilon Energy Services

How would you describe the company’s work-life balance?

Aquilon tailors its work-life balance with the individual in mind. As a software engineer, I’m crazy for coding; we get to tackle fun and challenging problems. But I’m also a family man. And my family is what it’s all about. Aquilon understands that not all challenges are the same and gives me the tools to help create an optimized work-life style.


Software Engineer

How do you collaborate with other teams in the company?

Even as a recent college grad, I work directly with people of all levels across Aquilon. This kind of collaboration and communication is rare! I have relationships with my fellow colleagues in and out of work. It is the best part of my job.


Customer Operations Analyst

How has your career grown since starting at the company?

Since coming to Aquilon, I’ve learned so much. There’s always an opportunity to develop new ideas and it’s extremely rewarding to see the direct impact of your work as we solve real problems for our customers. Being surrounded by such an incredible group of talented, creative individuals inspires me to achieve more.


Business Analyst

How do you empower your team to be more creative?

Our team is built upon the “best idea wins” mentality. No matter if you are just out of school or a seasoned 30 year veteran, a good idea can come from anyone. We encourage ideas to come at any time, from anywhere – and when one hits we strike quickly to collaborate, refine and transform that idea into action.


VP of Application Development

What’s the vibe like in the office?

The office is always light and cheery, even during “crunch” times. Everyone’s approachable and always willing to collaborate. With a collection of experts from different fields and different experiences, there’s always something new to learn. From collaborative meetings to fun company events, everyone exudes both a professional and familial vibe.


Software Engineer

What are Aquilon Energy Services Perks + Benefits

Friends outside of work
Eat lunch together
Daily stand up
Open door policy
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Onsite Gym
Retirement & Stock Options Benefits
Performance Bonus
Child Care & Parental Leave Benefits
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Fitness Subsidies
Professional Development Benefits
Lunch and learns
Acme Co. hosts lunch and learn meetings on occasion.
Promote from within
More Jobs at Aquilon Energy Services3 open jobs
All Jobs
Data + Analytics
Dev + Engineer
Data + Analytics